home *** CD-ROM | disk | FTP | other *** search
/ Amiga Plus 2002 #11 / Amiga Plus CD - 2002 - No. 11.iso / amigaoscd / amigapluscd / AP-Website / links / admin / sites_main.php < prev    next >
PHP Script  |  2001-07-22  |  5KB  |  223 lines
  1. <?
  2. // *******************************************************************
  3. //  admin/sites_main.php
  4. // *******************************************************************
  5.  
  6. include("../include/config.php");
  7. include("../include/functions.php");
  8.  
  9. include("../include/common.php");
  10. $language = $gl["Language"];
  11.  
  12. include("../include/lang/$language.php");
  13.  
  14. include("../include/session.php");
  15. session_start();
  16. ?>
  17. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  18. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> 
  19. <html>
  20. <head>
  21. <title></title>
  22. <link rel = "stylesheet" type = "text/css" href = "style.css" />
  23. </head>
  24. <?=$adm_body?>
  25. <?
  26. if(isset($submit)){    
  27.     
  28.     $total_sql = "
  29.         select
  30.             $tb_links.ID as link_id,
  31.             $tb_links.SiteURL as site_url,
  32.             $tb_links.SiteName as site_name,
  33.             $tb_categories.Category as cat_name
  34.         from
  35.             $tb_links
  36.         left join
  37.             $tb_categories
  38.         on
  39.             $tb_categories.ID=$tb_links.Category
  40.         where
  41.             $tb_links.Category='$Category'
  42.     ";
  43.  
  44.     if($Category == "0"){
  45.         
  46.         $total_sql = "
  47.             select
  48.                 $tb_links.ID as link_id,
  49.                 $tb_links.SiteURL as site_url,
  50.                 $tb_links.SiteName as site_name,
  51.                 $tb_categories.Category as cat_name
  52.             from
  53.                 $tb_links
  54.             left join
  55.                 $tb_categories
  56.             on
  57.                 $tb_categories.ID=$tb_links.Category
  58.             where
  59.                 $tb_links.Category='0'
  60.             or
  61.                 $tb_links.Category=''
  62.         ";
  63.     }
  64.  
  65.     if($Category == "-1"){
  66.         
  67.         $total_sql = "
  68.             select
  69.                 $tb_temp.ID as link_id,
  70.                 $tb_temp.SiteURL as site_url,
  71.                 $tb_temp.SiteName as site_name,
  72.                 '' as cat_name
  73.             from
  74.                 $tb_temp
  75.         ";
  76.     }
  77.  
  78.     $total_result = sql_query($total_sql);
  79.     $total_sites = sql_num_rows($total_result);
  80.     $pp=30;
  81.     $np=4;
  82.  
  83.     if(!isset($cp)){
  84.         $cp=0;
  85.     }
  86.  
  87.     if(!isset($sr)){
  88.         $sr=0;
  89.     }
  90.  
  91.     $nav_url = "sites_main.php?Category=" . $Category . "&submit=1i&";
  92.  
  93.     ?><table cellspacing="0" cellpadding="5" border="1" align="center" width="100%"><?
  94.     echo "<tr><td class=\"theader\" colspan=\"";
  95.  
  96.     if($Category > 0){
  97.         echo "5";
  98.     } else {
  99.         echo "4";
  100.     }
  101.  
  102.     echo "\">". nav_links($total_sites, $pp, $np, $cp, $nav_url) . "</td></tr>";
  103.     echo "<tr bgcolor=\"#EEEEEE\"><td class=\"theader\">Site Name</td>";
  104.  
  105.     if($Category > "0"){
  106.         
  107.         echo "<td class=\"theader\">Category</td>";
  108.     }
  109.  
  110.     echo "<td class=\"theader\">";
  111.  
  112.     if($Category == "-1"){
  113.         echo "Validate";
  114.     } else {
  115.         echo "Edit";
  116.     }
  117.  
  118.     echo "</td><td class=\"theader\">Reviews</td><td class=\"theader\">Delete</td></tr>";
  119.     
  120.     $sql = "
  121.         select
  122.             $tb_links.ID as link_id,
  123.             $tb_links.SiteURL as site_url,
  124.             $tb_links.SiteName as site_name,
  125.             $tb_categories.Category as cat_name
  126.         from
  127.             $tb_links
  128.         left join
  129.             $tb_categories
  130.         on
  131.             $tb_categories.ID=$tb_links.Category
  132.         where
  133.             $tb_links.Category='$Category'
  134.         limit
  135.             $sr, $pp
  136.     ";
  137.  
  138.     if($Category == "0"){
  139.         
  140.         $sql = "
  141.             select
  142.                 $tb_links.ID as link_id,
  143.                 $tb_links.SiteURL as site_url,
  144.                 $tb_links.SiteName as site_name,
  145.                 $tb_categories.Category as cat_name
  146.             from
  147.                 $tb_links
  148.             left join
  149.                 $tb_categories
  150.             on
  151.                 $tb_categories.ID=$tb_links.Category
  152.             where
  153.                 $tb_links.Category='0'
  154.             or
  155.                 $tb_links.Category=''
  156.             limit
  157.                 $sr, $pp
  158.         ";
  159.     }
  160.  
  161.     if($Category == "-1"){
  162.         
  163.         $sql = "
  164.             select
  165.                 $tb_temp.ID as link_id,
  166.                 $tb_temp.SiteURL as site_url,
  167.                 $tb_temp.SiteName as site_name,
  168.                 '' as cat_name
  169.             from
  170.                 $tb_temp
  171.             limit
  172.                 $sr, $pp
  173.         ";
  174.     }
  175.  
  176.     $result = sql_query($sql);
  177.  
  178.     while($rows = sql_fetch_array($result)){
  179.  
  180.         echo "<tr><td><a href=\"" . $rows[site_url] . "\" target=\"_blank\">";
  181.         echo stripslashes($rows[site_name]) . "</a></td>";
  182.  
  183.         if($Category > "0"){
  184.             
  185.             echo "<td class=\"text\">" . eregi_replace("_", " ", $rows[cat_name]) . "</td>";
  186.         }
  187.  
  188.         echo "<td>";
  189.         
  190.         if($Category == "-1"){
  191.             
  192.             echo "<a href=\"validate.php?" . session_name() . "=" . session_id();
  193.             echo "&ID=" . $rows[link_id];
  194.             echo "\">Validate</a>";
  195.         } else {
  196.             
  197.             echo "<a href=\"edit_site.php?" . session_name() . "=" . session_id();
  198.             echo "&ID=" . $rows[link_id];
  199.             echo "\">Edit</a>";
  200.         }
  201.  
  202.         echo "</td><td><a href=\"reviews.php?" . session_name() . "=";
  203.         echo session_id() . "&SiteID=" . $rows[link_id];
  204.         echo "\">Reviews</a></td><td><a href=\"delete_site.php?";
  205.         echo session_name() . "=" . session_id() . "&dbtable=";
  206.         
  207.         if($Category >= "0"){
  208.             
  209.             echo "links";
  210.         } else {
  211.             
  212.             echo "temp";
  213.         }
  214.  
  215.         echo "&ID=" . $rows[link_id] . "\">Delete</a></td></tr>";
  216.     }
  217.     
  218.     echo "</table>";
  219. }
  220. ?>
  221. </body>
  222. </html>
  223.